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

in sql server

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

--oracle SELECT Name FROM STUDENTS WHERE Marks > 75 ORDER BY SUBSTR(Name, -3), ID;

Here is my solution (I know that there are some unnecessary columns in the CTE, however, it was the easiest way to check the output step by step in my case); with

ORDERED AS
(
select marks,ID,
concat(
substr(Name,length(name)-2,1),substr(Name,length(Name)-1,1),substr(Name,length(Name),1)
    ) AS LAST,
Name
from STUDENTS where Marks>75
order by LAST ASC, ID ASC
)
select Name from ORDERED

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