Brian May has been left “heartbroken” after sewage flooded his London home and destroyed many of his treasured possessions on Monday.