What you want is a natural sort.
It isn't supported by any db that I'm aware of.
The reason for this is that most indexing of databases uses B-Tree index where B stands for Binary. Sorting uses the index.
So natural sorting would need a full table scan which in many cases would be a serious performance hit.
Here[
^] is an article on how to implement natural sorting using C#.