Sydney has scored hosting rights for the 2027 Rugby World Cup final as Melbourne was unveiled as a tournament host.