Use case

LIMIT -10
- return 10 last records (regardless of total number of records).

Can be combined with negative offset (but not with positive offset).

Describe the solution you'd like

Just implement it.

Describe alternatives you've considered

SELECT * (SELECT ... ORDER BY x DESC LIMIT 10) ORDER BY x ASC

But it's more cumbersome.