The Queen was advised to give up horse riding two months ago after suffering 'discomfort' in Scotland. Her Majesty,…