The Brit Awards will be held in Manchester for the very first time in 2026 and 2027 as part of a two-year-deal.