The late Queen has inspired demand for the breed but, cute as they are, don’t be fooled into thinking it’s like owning a golden retriever