I would not discuss a specific job change outside the company with your manager. You put them in the untenable position of trying to be helpful to you and doing their job in representing the company. If their are matters which cause you concern about your job by all means discuss them with your manager. However, if you are evaluating pros and cons of leaving the company it will most likely permanently impair your situation at the current company. Even if your manager convinces you to stay at the company, you have put them on notice that you are looking around and were about ready to leave. Depending on your role, that will likely cause your manager to look elsewhere when selecting people for key projects, advancement, etc.
Coming to a manager with a discussion about another job, especially if you initiated the search (out of the blue offers are not so bad), feels like an ambush. Usually the manager has little time to respond with a counteroffer and must use lots of political capital to make it happen. They cannot help but wonder why you did not discuss the issues that are causing you to leave earlier when they could have done something about them.