How to select rows after a certain row using auto increment temporary columns
Use HAVING for checking rownames
SELECT
   (@cnt := @cnt + 1) AS `rowNumber`, ID  
  from table1
  CROSS JOIN (SELECT @cnt := 0) AS n 
where 
  (
    (1 = 1
    )
  )
  and date &gt; '2020-08-06 08:51:23.08'
  HAVING `rowNumber` &gt; 4
  ORDER BY ID  
  LIMIT 10
;