MySQL seek-method / keyset pagination?
You effectively have a 2-column ordering.  So, when &quot;remembering where you left off&quot;, you must include both columns.  Then, the &gt; becomes more complex.  I discuss that in a couple of places:
Should I store data pre-ordered rather than ordering on the fly?
http://mysql.rjweb.org/doc.php/deletebig#iterating_through_a_compound_key
General discussion of avoiding OFFSET for pagination:  http://mysql.rjweb.org/doc.php/pagination
Granted, the use of FIELD() adds a wrinkle.  But not a big wrinkle.  Simply use the function call instead of a column name in a few places.