Ordenar por los 3 ultimos numeros

[FOURIER]

se me ocurre

select * from Tabla order by int(right(campoordenar,3));