Singer Sir Elton John has achieved his ninth UK number one album with Diamonds, a greatest hits compilation, the Official Charts Company has confirmed.