It is responsibility of database to correctly OFFSET specified number of records.

If the table suffered inserts or deletes, or database fetching records in a different order for different SQL executions, your subsequent queries may start on an incorrect row - not on the row that was right after the last fetched row at previous SQL execution.

It's best to use partitioning by Primary Key or other numeric index. This way the borders of the chunks become exact.