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