I ran into this same problem with Hive Engine Tools and now Hive Analytics.
The easy solution is fetch by ID then use last id rather than offset pagination.
Right now Hive Analytics just uses offset, but when I refactor it, it will pull entire list then use server side sorting from cache.
RE: There Has to Be a Better Way: Sorting Hive-Engine Balances