Missing rows when paging an API

A job pages through /orders?offset=0&limit=100, then offset=100 and so on, sorted by created_at. New orders arrive during the run and some orders are skipped or repeated. What fixes it?