US President Donald Trump has been banned from entering the major British city Sheffield during his upcoming state visit to the UK, Lord Mayor Magid Magid says.