The King was "flabbergasted" after a magician turned pieces of newspaper into £20 notes as he and the Queen visited Bradford in West Yorkshire.