All values in the table are currently sorted as strings, so “ABC 10” indeed comes before “ABC 2”. For more details, please see this post.
As a workaround to get numeric order, you would have to ensure each number has the same number of digits (i.e, “ABC 02” comes before “ABC 11”). In the long term, we’ll be looking to add support for more value types and improved sorting for partially numeric values.