Desordenar un SQL

[quimfv]

Código MySQL:

SELECT * FROM
(SELECT id FROM mitabla ORDER BY id DESC limit 0, 8) as sbc
ORDER BY rand()
 

No lo he probado perooooo

Quim