One way is to add a table which defines the order messages and use that lookup table to sort the data.
Consider the following
DECLARE @Table TABLE
(minv_code INT,
alert_msg varchar(10),
alert_time Datetime)
INSERT INTO @Table VALUES
(873939, 'Reverse', '7/24/2015 3:31:18'),
(873939, 'Tamper', '7/24/2015 3:30:00'),
(873939, 'Meter', '7/24/2015 3:31:22'),
(873940, 'Reverse', '7/24/2015 3:30:00'),
(873940, 'Tamper', '7/24/2015 3:31:22')
select a.minv_code, a.alert_msg, a.alert_time
from @Table a,
(select 1 as ordinal, 'Meter' as alert_msg union all
select 2 as ordinal, 'Tamper' as alert_msg union all
select 3 as ordinal, 'Reverse' as alert_msg) b
where a.alert_msg = b.alert_msg
order by a.minv_code, b.ordinal;