Significantly more people in Northern Ireland consider themselves British as opposed to Irish, answers to a new census question have indicated.