Prince Edward and wife Sophie earned an undisclosed sum after renting out a unit in the grounds of their Bagshot Park mansion to the Royal Collection Trust.