SQL order by after more than

Question

I am trying SQL to sort results

id | name (table name: student)
-----
1 | jhon
2 | amin
3 | heli
4 | mir
5 | mrs
6 | amr
7 | jonnathan
8 | adhy

When i use this query

select id from studenth where id>='3' order by id DESC limit 2

The result that appears is

id | name (table name: student)
-----
8 | adhy
7 | jonnathan

Whereas I want to sort results after id = 3, I want the data as below

id | name (table name: student)
-----
4 | mir
3 | heli

Answer 1

select * from (select id from student where id >= 3 order by id limit 2) r order by r.id desc