select id, Total
from (
    select id, Total
    from bar
    order by id desc
    limit 10
) baz
order by Total desc;