Right, substr, substring都可以

select first_name from employees
order by right(first_name,2);

select first_name from employees
order by substr(first_name,-2);

select first_name from employees
order by substring(first_name,-2);