I have a table like:
This will do it, very simply selecting the right-most 3 characters and ordering by that value ascending.
SELECT * FROM table_name ORDER BY RIGHT(name, 3) ASC;
It should be added that as your data grows, this will become an inefficient solution. Eventually, you'll probably want to store the numeric appendix in a separate, indexed integer column, so that sorting will be optimally efficient.