North Yorkshire dignitaries honour the Queen at Ripon Cathedral