Sir Rod Stewart has told the King he was "absolutely superb" during his recent state visit to the US, adding that His Majesty "put that little ratbag in his place".