I suspect the OP will want to be in Manchester quite a bit before midday, assuming they want a full day's activities before returning. The 9.40, being the first off-peak train, will most likely be very full too.
My point is you should always check and not expect to be able to just walk up and get a ticket for a reasonable price.