Green group amendments tabled in 2019 and 2020 suggested more than £6 million would be generated by forcing non-residents to pay to drive into the city centre