A Japanese MP who sparked a national debate about paternity leave has quit after admitting to having an affair as his wife was due to give birth.