How to get last 10 records from MYSQL in reverse order?

Question

MySQL

How can I pull out the last 10 records from the table (for example ORDER BY ID, DESC LIMIT 10), but at the same time, so that they are in reverse order, for example:
10 last records in normal order:
1,2,3,4,5,6 ,7,8,9,10 Last
10 records in reverse order:
10,9,8,7,6,5,4,3,2,1

Answer 1

I solved it in the following way:

collect(Model::orderBy('id','desc')->take(10)->get())->reverse();

Answer 2

SELECT * FROM (SELECT * FROM `table_name` ORDER BY `id` DESC LIMIT 10) AS `table_name` ORDER BY `id` ASC

Answer 3

The easiest way is to reverse the order in php