offset and limit when codition is used mysql code example

SELECT * FROM `members` LIMIT 1, 2;