Decision comes after Supreme Court rules previous policy discriminatory as it prevented same-sex couples from access; ‘equality before the law and equality of parenthood’, openly-gay minister says