codice:
SELECT campo
FROM tabella

order by mid(campo, 2, 1)