Activity in the UK’s manufacturing sector grew at a slower pace last month amid a drop in business optimism, according to new data.