VIDEO: New footage of last confirmed sighting of missing Scot serviceman