The Manchester-based brewery – which for many years avoided supermarket retail – will hit the supermarket’s shelves this month