prova così

select * from tabella order by cast(nome_campo as signed)