How get last 5 records (in ASC order)

[comfixit]

Say I have a data field I am sorting by with the following values 1,2,3,4,5,6,7,8,9,10.

If I were to limit 5 I would get 1,2,3,4,5

If I were to limit 5 and order desc I would get 10,9,8,7,6

What I want to get is 6,7,8,9,10

Does anyone know a good way to limit a search to the last 5 records while keeping the data in ASC order in MySql?

[guido2004]

SELECT
   ...
FROM 
  (SELECT 
      ...
   FROM table
   ORDER BY id DESC
   LIMIT 5
  ) AS a
ORDER BY id