Queen Elizabeth's family persuaded her to stay at Balmoral for her final days as she had worried being in Scotland would make her funeral "difficult" to organise.