Prince Andrew will miss Queen Elizabeth's "humour" as he spoke out in a tribute to his mother on the eve of her funeral.