Rory McIlroy says he had dreamt of winning a golf major and it feels "very nice" to have won the US Open.