mysql get last 4 characters code example

Example: get last three characters in mysql column

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