MySQL order by alphabet - numeric

Question

Is there any way to sort Elements in MySQL like this:

Elements:

1. City 1
2. City 2
3. City 10
4. City 1a

When i do the ORDER BY the list looks this way:

1. City 1
2. City 1a
3. City 10
4. City 2

Because all answer did not match to my special problem i edit my question. There are also Elements with Chars behind the numbers. Watch the example

Answer 1

I use this and it works well:

ORDER BY LENGTH(Elements), Elements

Answer 2

Try this trick - 'ORDER BY column_name+1', e.g.:

SELECT * FROM element
ORDER BY column_name+1;