MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE t
    (`id` int, `gender` varchar(1), `name` varchar(6))
;
    
INSERT INTO t
    (`id`, `gender`, `name`)
VALUES
    (1, 'f', 'kate'),
    (2, 'm', 'john'),
    (3, 'f', 'monica'),
    (4, 'f', 'zoey'),
    (5, 'm', 'perry'),
    (6, 'f', 'mary'),
    (7, 'm', 'paul'),
    (8, 'f', 'carol'),
    (9, 'm', 'mark'),
    (10, 'm', 'ross'),
    (11, 'f', 'emily'),
    (12, 'm', 'Jay'),
    (13, 'm', 'Mike')
;
SELECT * FROM t
WHERE gender = 'm'
ORDER BY ID DESC


id
gender
name


13
m
Mike

12
m
Jay

10
m
ross

9
m
mark

7
m
paul

5
m
perry

2
m
john


SELECT * FROM t
WHERE gender = 'm'
ORDER BY ID DESC
LIMIT 3 OFFSET 3 


id
gender
name


9
m
mark

7
m
paul

5
m
perry