[Solved] MySQL query?

Question

SQL

Friends, the head does not cook, help the collective mind.
Let's assume the situation.
MySQL table with one field `id`
id
1
2
3
4
5
6
7
8
9
10
You need to select the last 5 records that are greater than 2 with the condition that the id sort is ascending. — i.e. the result should be 6,7,8,9,10

SELECT * FROM `table` WHERE id > '2' ORDER BY id ASC LIMIT 5

will obviously choose 3,4,5,6,7

SELECT * FROM `table` WHERE id > '2' ORDER BY id DESC LIMIT 5

will select the desired records, but incorrectly sorted.
How?

Answer 1

(
SELECT *
FROM `table`
WHERE id > '2'
ORDER BY id DESC
LIMIT 5
)
ORDER BY id ASC

Answer 2

select `id` from (select `id` from `table` where `id`>2 order by `id` desc limit 5) as `tmptable` order by `id` desc