Paul Fiddler, who was in his 40s and an assistant manager at a non-league football team, was pronounced dead at the scene on the A59 in Longton, Lancashire on Saturday afternoon