‘Cowboy Carter’ star enjoyed a historic night while fellow artists Kendrick Lamar, Sabrina Carpenter and Chappell Roan scooped top prizes