Waters said Facebook offered a ‘huge, huge amount of money’ for rights to ‘Another Brick in the Wall, Part 2’