The Archbishop of Canterbury has apologised for the "pain, trauma and stigma" caused by the Church of England's role in historical forced adoptions.