City snatched a dramatic late victory on the road in Lancashire