Legal aid should be given automatically to people suffering domestic abuse who want help from a solicitor, a Holyrood committee has heard.