Two-sided LIMIT in MySQL
The LIMIT clause intended to do what you need: 

SELECT * 
  FROM food 
 LIMIT 1,2  -- offset, count
;


Refer to the SELECT syntax manual for details: https://dev.mysql.com/doc/refman/8.0/en/select.html