Britain is suffering from the “catastrophic” impact of Brexit and should consider a closer trading relationship with the EU, according to the Asda chair.