No one expected him to sing it — but Arch Manning’s National Anthem just brought the entire arena to tears