Order by alphabet and then by numbers
For your request:


  sorted by alphabets and then by numeric values


I assume (deriving from your sample data) you want to ORDER BY:


The first letter, treated as text.
The first number (consecutive digits), treated as integer.
The whole string to break remaining ties, treated as text. May or may not be needed.




SELECT *
FROM   tbl
ORDER  BY left(col, 1)  -- 1st letter as text
     , substring(fest, '\d+')::int NULLS FIRST  -- first number in string as int
     , col  -- whole columns as cheap tiebreaker


SQL Fiddle.

More details:


Alphanumeric sorting with PostgreSQL
Humanized or natural number sorting of mixed word-and-number strings