The mayor and deputy mayor of York and North Yorkshire have said they are “devasted” by the death of a police officer and man on the A19.