Steven Thompson was allegedly behind the wheel of a refuse collection vehicle when a collision happened at a BP garage in the Northumberland town