offset with where coondition in mysql code example

Example: mysql limit

SELECT * FROM `members` LIMIT 1, 2;