Please run this SQL Query
SQL
DECLARE @TABLE TABLE(ID Int,[Time] VARCHAR(20))
INSERT INTO @TABLE VALUES(1, '08:00 PM')
INSERT INTO @TABLE VALUES(2, '08:00 PM')
INSERT INTO @TABLE VALUES(3, '09:00 AM')
INSERT INTO @TABLE VALUES(4, '10:00 AM')
SELECT * FROM @TABLE
ORDER BY CAST([Time] AS DATETIME)
Output
ID Time
3 09:00 AM
4 10:00 AM
1 08:00 PM
2 08:00 PM