add sort order

we need something to sort by if we want consistent & predictable pagination.
none of the promo fields are indexed so let's just sort by id with most-recent first.