offers repository: fetch offer by shop id