Mamdani's supporters said they were 'elated' and 'hopeful' after the Democrat candidate was elected as the new mayor of New York City