Scott Mann MP must resign as a councillor