I’ll be arriving at Hanoi Airport late at night (at 01:15), can I pick up the Visa on arrival?

Yes. The VOA counter at all international airports of Vietnam works 24/7, as such you can pick up your visa at any time upon your landing.