Northern Ireland and Scotland will not be able to attain special EU status in the wake of Brexit, Theresa Villiers has said.