How to get next X results in pagination

BTW, I have shared this some time ago How to store ordered data? - #4 by MichelDiz it could be useful, cuz it is a linked list of nodes. So it is a fixed ordering. It is a bit complex, but it works.