Rod Stewart was diagnosed with thyroid cancer following a routine health check and the singer has described the moment he got the news