check last three character of string in mysql code example

Example: get last three characters in mysql column

SELECT NAME FROM STUDENTS WHERE MARKS > 75 ORDER BY SUBSTRING(NAME,-3), ID;