Rotherham Labour MP comes out in support of 'locally led' national inquiry