“Thank you all for your kind thoughts, words and prayers,” said 87-year-old singer, who has been moved to a private room after undergoing tests to determine the cause of her pain