Sweet Vidalia onions are the quintessential choice, but you could also use yellow onions. Personally, I like to use a blend of Vidalia and yellow onions, it makes the soup slightly more robust without being overly sweet.  I’ve never used white or red onions myself because I don’t personally feel that they’re the best choice, but you could, just expect a different flavor profile.