xxxxxxxxxx
select Name from STUDENTS where Marks>75 order by right(Name,3),ID ASC;
xxxxxxxxxx
SELECT *
FROM your_table
ORDER BY SUBSTRING(your_column, LENGTH(your_column) - 2)
xxxxxxxxxx
SELECT inft.port FROM interfaces AS intf ORDER BY SUBSTRING(intf.port, LOCATE('/', intf.port)+1, LENGTH(intf.port)) + 0