Consumers are feeling more optimistic about their personal finances - but worse about the overall state of the UK economy, according to a closely watched survey.