Without knowing the exact error message, it's quite impossible to say what the problem is.
However, if the TagNumber is unique, you could try an alternate version just in case. One point is that you haven't defined the tables for your columns in the query and older versions may have problems with scalars in between.
So try something like:
SELECT mc.TagNumber,
mc.ParkingType,
mc.DistanceToNextTag
FROM MyCar mc
WHERE mc.Id >= (SELECT mc2.Id FROM MyCar mc2 WHERE mc2.TagNumber=6554)
AND mc.Id <= (SELECT mc2.Id FROM MyCar mc2 WHERE mc2.TagNumber=65635)