The Mayor of Greater Manchester signalled he was supportive of calls for a new nationwide investigation into the historical child sexual abuse.