Probably the simplest way to sort your problem as currently stated is to change the where clause on the 2nd query in the UNION e.g.
SELECT top 6 L_ID, L_Name, 1 as OBCol
FROM Locations where L_Name like 'ban%'
UNION
SELECT top 4 L_ID, L_Name, 2 as OBCol
FROM Locations where L_Name like '%ban%' and L_Name NOT LIKE 'ban%'
order by OBCol
Alternatively you could drop the UNION all together and work out the value OBCol using CASE
SELECT L_ID, L_Name,
CASE WHEN L_Name like 'ban%' THEN 1 ELSE 2 END as OBCol
FROM Locations where L_Name like '%ban%'
order by OBCol