A man has been shot in the legs during a home invasion in Brisbane's north.