How can I get rows after a specific row, from a resultset of a specific sort order?
Plan A. You need the entire set of columns that you are ordering by.  Let's say you left off at a=4 AND b=11 AND c=2
If you are going ascending, then
WHERE (a, b, c) &gt; (4, 11, 2)

For all DESC, change to &lt;
Caveat:  &quot;row constructors&quot; like that were not optimized until 5.7.
For a mixture, please provide a 2-column example without UUIDs.  Provide CREATE TABLE and sample data.  Preferrably ready to run in a 'fiddle'.
Plan B  This is like the row_number(), which is not available before 8.0.
Create a table with a new AUTO_INCREMENT.  If all the work is in a single connection, use a TEMPORARY TABLE.  Then lean on that new id for &quot;remembering where you left off&quot;.